﻿
function  produceRoomData(bool) {
	
	if (!bool) return;
	/* 新手場 */
	for (var i = 1; i <= 50 ; i++ ){	
		var sql = "INSERT INTO `texas_room` (`room_id` ,`room_name` ,`room_pass` ,`room_type` ,`room_min_blind` ,`room_max_blind` ,`room_min_chip` ,`room_max_chip`, `room_max_user` ,`room_max_sper` ,`room_marks` ,`room_expend` ,`room_isgame` ,`room_islimbo` ,`room_extension` ,`room_class`)VALUES (NULL , '新手場"+ i +"', '', '1', '1', '2', '20', '400', '500', '500', '1', '0', '1', '0', '', '')";		
		__conn.execute(sql);	
	}
	
	/* 初级場 */
	var _counter = 0;
	for (var i = 1; i <= 10 ; i++ ){	
		var sql = "INSERT INTO `texas_room` (`room_id` ,`room_name` ,`room_pass` ,`room_type` ,`room_min_blind` ,`room_max_blind` ,`room_min_chip` ,`room_max_chip`, `room_max_user` ,`room_max_sper` ,`room_marks` ,`room_expend` ,`room_isgame` ,`room_islimbo` ,`room_extension` ,`room_class`)VALUES (NULL , '初级場"+ i +"', '', '2', '2', '4', '40', '800', '500', '500', '2', '0', '1', '0', '', '')";		
		__conn.execute(sql);	
	}
	_counter = i + 10; 
	for (; i <= _counter ; i++ ){	
		var sql = "INSERT INTO `texas_room` (`room_id` ,`room_name` ,`room_pass` ,`room_type` ,`room_min_blind` ,`room_max_blind` ,`room_min_chip` ,`room_max_chip`, `room_max_user` ,`room_max_sper` ,`room_marks` ,`room_expend` ,`room_isgame` ,`room_islimbo` ,`room_extension` ,`room_class`)VALUES (NULL , '初级場"+ i +"', '', '2', '2', '4', '100', '2000', '500', '500', '2', '0', '1', '0', '', '')";		
		__conn.execute(sql);	
	}
	_counter = i + 10;
	for (; i <= _counter ; i++ ){	
		var sql = "INSERT INTO `texas_room` (`room_id` ,`room_name` ,`room_pass` ,`room_type` ,`room_min_blind` ,`room_max_blind` ,`room_min_chip` ,`room_max_chip`, `room_max_user` ,`room_max_sper` ,`room_marks` ,`room_expend` ,`room_isgame` ,`room_islimbo` ,`room_extension` ,`room_class`)VALUES (NULL , '初级場"+ i +"', '', '2', '2', '4', '200', '4000', '500', '500', '2', '0', '1', '0', '', '')";		
		__conn.execute(sql);	
	}
	
	/* 中级場 */
	_counter = 0;
	for (var i = 1; i <= 10 ; i++ ){	
		var sql = "INSERT INTO `texas_room` (`room_id` ,`room_name` ,`room_pass` ,`room_type` ,`room_min_blind` ,`room_max_blind` ,`room_min_chip` ,`room_max_chip`, `room_max_user` ,`room_max_sper` ,`room_marks` ,`room_expend` ,`room_isgame` ,`room_islimbo` ,`room_extension` ,`room_class`)VALUES (NULL , '中級場"+ i +"', '', '3', '25', '50', '500', '2000', '500', '500', '3', '5', '1', '0', '', '')";		
		__conn.execute(sql);	
	}
	_counter = i + 20;
	for (; i <= _counter ; i++ ){	
		var sql = "INSERT INTO `texas_room` (`room_id` ,`room_name` ,`room_pass` ,`room_type` ,`room_min_blind` ,`room_max_blind` ,`room_min_chip` ,`room_max_chip`, `room_max_user` ,`room_max_sper` ,`room_marks` ,`room_expend` ,`room_isgame` ,`room_islimbo` ,`room_extension` ,`room_class`)VALUES (NULL , '中級場"+ i +"', '', '3', '50', '100', '1000', '20000', '500', '500', '3', '10', '1', '0', '', '')";		
		__conn.execute(sql);	
	}
	_counter = i + 10;
	for (; i <= _counter ; i++ ){	
		var sql = "INSERT INTO `texas_room` (`room_id` ,`room_name` ,`room_pass` ,`room_type` ,`room_min_blind` ,`room_max_blind` ,`room_min_chip` ,`room_max_chip`, `room_max_user` ,`room_max_sper` ,`room_marks` ,`room_expend` ,`room_isgame` ,`room_islimbo` ,`room_extension` ,`room_class`)VALUES (NULL , '中級場"+ i +"', '', '3', '100', '200', '2000', '40000', '500', '500', '3', '20', '1', '0', '', '')";		
		__conn.execute(sql);	
	}
	
	/* 高级場 */
	_counter = 0;
	for (var i = 1; i <= 5 ; i++ ){	
		var sql = "INSERT INTO `texas_room` (`room_id` ,`room_name` ,`room_pass` ,`room_type` ,`room_min_blind` ,`room_max_blind` ,`room_min_chip` ,`room_max_chip`, `room_max_user` ,`room_max_sper` ,`room_marks` ,`room_expend` ,`room_isgame` ,`room_islimbo` ,`room_extension` ,`room_class`)VALUES (NULL , '高級場"+ i +"', '', '4', '200', '400', '4000', '80000', '500', '500', '4', '40', '1', '0', '', '')";		
		__conn.execute(sql);	
	}
	_counter = i + 10;
	for (; i <= _counter ; i++ ){	
		var sql = "INSERT INTO `texas_room` (`room_id` ,`room_name` ,`room_pass` ,`room_type` ,`room_min_blind` ,`room_max_blind` ,`room_min_chip` ,`room_max_chip`, `room_max_user` ,`room_max_sper` ,`room_marks` ,`room_expend` ,`room_isgame` ,`room_islimbo` ,`room_extension` ,`room_class`)VALUES (NULL , '高級場"+ i +"', '', '4', '500', '1000', '10000', '200000', '500', '500', '4', '100', '1', '0', '', '')";		
		__conn.execute(sql);	
	}
	_counter = i + 5;
	for (; i <= _counter ; i++ ){	
		var sql = "INSERT INTO `texas_room` (`room_id` ,`room_name` ,`room_pass` ,`room_type` ,`room_min_blind` ,`room_max_blind` ,`room_min_chip` ,`room_max_chip`, `room_max_user` ,`room_max_sper` ,`room_marks` ,`room_expend` ,`room_isgame` ,`room_islimbo` ,`room_extension` ,`room_class`)VALUES (NULL , '高級場"+ i +"', '', '4', '1000', '2000', '20000', '400000', '500', '500', '4', '200', '1', '0', '', '')";		
		__conn.execute(sql);	
	}
	_counter = i + 5;
	for (; i <= _counter ; i++ ){	
		var sql = "INSERT INTO `texas_room` (`room_id` ,`room_name` ,`room_pass` ,`room_type` ,`room_min_blind` ,`room_max_blind` ,`room_min_chip` ,`room_max_chip`, `room_max_user` ,`room_max_sper` ,`room_marks` ,`room_expend` ,`room_isgame` ,`room_islimbo` ,`room_extension` ,`room_class`)VALUES (NULL , '高級場"+ i +"', '', '4', '2000', '4000', '40000', '800000', '500', '500', '4', '600', '1', '0', '', '')";		
		__conn.execute(sql);	
	}
	_counter = i + 5;
	for (; i <= _counter ; i++ ){	
		var sql = "INSERT INTO `texas_room` (`room_id` ,`room_name` ,`room_pass` ,`room_type` ,`room_min_blind` ,`room_max_blind` ,`room_min_chip` ,`room_max_chip`, `room_max_user` ,`room_max_sper` ,`room_marks` ,`room_expend` ,`room_isgame` ,`room_islimbo` ,`room_extension` ,`room_class`)VALUES (NULL , '高級場"+ i +"', '', '4', '5000', '10000', '100000', '2000000', '500', '500', '4', '1500', '1', '0', '', '')";		
		__conn.execute(sql);	
	}
	_counter = i + 5;
	for (; i <= _counter ; i++ ){	
		var sql = "INSERT INTO `texas_room` (`room_id` ,`room_name` ,`room_pass` ,`room_type` ,`room_min_blind` ,`room_max_blind` ,`room_min_chip` ,`room_max_chip`, `room_max_user` ,`room_max_sper` ,`room_marks` ,`room_expend` ,`room_isgame` ,`room_islimbo` ,`room_extension` ,`room_class`)VALUES (NULL , '高級場"+ i +"', '', '4', '10000', '20000', '200000', '4000000', '500', '500', '4', '4000', '1', '0', '', '')";		
		__conn.execute(sql);	
	}
	_counter = i + 5;
	for (; i <= _counter ; i++ ){	
		var sql = "INSERT INTO `texas_room` (`room_id` ,`room_name` ,`room_pass` ,`room_type` ,`room_min_blind` ,`room_max_blind` ,`room_min_chip` ,`room_max_chip`, `room_max_user` ,`room_max_sper` ,`room_marks` ,`room_expend` ,`room_isgame` ,`room_islimbo` ,`room_extension` ,`room_class`)VALUES (NULL , '高級場"+ i +"', '', '4', '20000', '40000', '400000', '8000000', '500', '500', '4', '8000', '1', '0', '', '')";		
		__conn.execute(sql);	
	}
	
	/* 快速場 */
	_counter = 0;
	for (var i = 1; i <= 5 ; i++ ){	
		var sql = "INSERT INTO `texas_room` (`room_id` ,`room_name` ,`room_pass` ,`room_type` ,`room_min_blind` ,`room_max_blind` ,`room_min_chip` ,`room_max_chip`, `room_max_user` ,`room_max_sper` ,`room_marks` ,`room_expend` ,`room_isgame` ,`room_islimbo` ,`room_extension` ,`room_class`)VALUES (NULL , '快速場"+ i +"', '', '5', '50', '100', '1000', '20000', '500', '500', '1', '10', '1', '0', '', '')";		
		__conn.execute(sql);	
	}	
	_counter = i + 5;
	for (; i <= _counter ; i++ ){	
		var sql = "INSERT INTO `texas_room` (`room_id` ,`room_name` ,`room_pass` ,`room_type` ,`room_min_blind` ,`room_max_blind` ,`room_min_chip` ,`room_max_chip`, `room_max_user` ,`room_max_sper` ,`room_marks` ,`room_expend` ,`room_isgame` ,`room_islimbo` ,`room_extension` ,`room_class`)VALUES (NULL , '快速場"+ i +"', '', '5', '100', '200', '2000', '40000', '500', '500', '2', '20', '1', '0', '', '')";		
		__conn.execute(sql);	
	}
	_counter = i + 5;
	for (; i <= _counter ; i++ ){	
		var sql = "INSERT INTO `texas_room` (`room_id` ,`room_name` ,`room_pass` ,`room_type` ,`room_min_blind` ,`room_max_blind` ,`room_min_chip` ,`room_max_chip`, `room_max_user` ,`room_max_sper` ,`room_marks` ,`room_expend` ,`room_isgame` ,`room_islimbo` ,`room_extension` ,`room_class`)VALUES (NULL , '快速場"+ i +"', '', '5', '200', '400', '2000', '80000', '500', '500', '4', '40', '1', '0', '', '')";		
		__conn.execute(sql);	
	}
	_counter = i + 5;
	for (; i <= _counter ; i++ ){	
		var sql = "INSERT INTO `texas_room` (`room_id` ,`room_name` ,`room_pass` ,`room_type` ,`room_min_blind` ,`room_max_blind` ,`room_min_chip` ,`room_max_chip`, `room_max_user` ,`room_max_sper` ,`room_marks` ,`room_expend` ,`room_isgame` ,`room_islimbo` ,`room_extension` ,`room_class`)VALUES (NULL , '快速場"+ i +"', '', '5', '500', '1000', '10000', '200000', '500', '500', '4', '100', '1', '0', '', '')";		
		__conn.execute(sql);	
	}
	_counter = i + 5;
	for (; i <= _counter ; i++ ){	
		var sql = "INSERT INTO `texas_room` (`room_id` ,`room_name` ,`room_pass` ,`room_type` ,`room_min_blind` ,`room_max_blind` ,`room_min_chip` ,`room_max_chip`, `room_max_user` ,`room_max_sper` ,`room_marks` ,`room_expend` ,`room_isgame` ,`room_islimbo` ,`room_extension` ,`room_class`)VALUES (NULL , '快速場"+ i +"', '', '5', '1000', '2000', '20000', '400000', '500', '500', '4', '200', '1', '0', '', '')";		
		__conn.execute(sql);	
	}
	_counter = i + 5;
	for (; i <= _counter ; i++ ){	
		var sql = "INSERT INTO `texas_room` (`room_id` ,`room_name` ,`room_pass` ,`room_type` ,`room_min_blind` ,`room_max_blind` ,`room_min_chip` ,`room_max_chip`, `room_max_user` ,`room_max_sper` ,`room_marks` ,`room_expend` ,`room_isgame` ,`room_islimbo` ,`room_extension` ,`room_class`)VALUES (NULL , '快速場"+ i +"', '', '5', '2000', '4000', '40000', '800000', '500', '500', '4', '600', '1', '0', '', '')";		
		__conn.execute(sql);	
	}
	_counter = i + 5;
	for (; i <= _counter ; i++ ){	
		var sql = "INSERT INTO `texas_room` (`room_id` ,`room_name` ,`room_pass` ,`room_type` ,`room_min_blind` ,`room_max_blind` ,`room_min_chip` ,`room_max_chip`, `room_max_user` ,`room_max_sper` ,`room_marks` ,`room_expend` ,`room_isgame` ,`room_islimbo` ,`room_extension` ,`room_class`)VALUES (NULL , '快速場"+ i +"', '', '5', '5000', '10000', '100000', '2000000', '500', '500', '4', '1500', '1', '0', '', '')";		
		__conn.execute(sql);	
	}
	
	/* 比賽場 */
	_counter = 0;
	for (var i = 1; i <= 10 ; i++ ){	
		var sql = "INSERT INTO `texas_race_room` (`room_id` ,`room_name` ,`room_pass` ,`room_type`,`room_buy` ,`room_cost` ,`room_players` ,`room_expend` ,`room_first_bonus` ,`room_second_bonus` ,`room_third_bonus` ,`room_first_marks` ,`room_second_marks` ,`room_third_marks` ,`room_extension`, `room_class`)VALUES (NULL, '比賽場"+ i +"', '', '6', '10000', '1000', '9', '11000', '45000', '27000', '18000', '3', '2', '1', '' ,'')";
		__conn.execute(sql);	
	}	
	_counter = i + 10;
	for (; i <= _counter ; i++ ){	
		var sql = "INSERT INTO `texas_race_room` (`room_id` ,`room_name` ,`room_pass` ,`room_type`,`room_buy` ,`room_cost` ,`room_players` ,`room_expend` ,`room_first_bonus` ,`room_second_bonus` ,`room_third_bonus` ,`room_first_marks` ,`room_second_marks` ,`room_third_marks` ,`room_extension`, `room_class`)VALUES (NULL, '比賽場"+i+"', '','6',  '20000', '2000', '9', '22000', '90000', '54000', '36000', '3', '2', '1', '' ,'')";
		__conn.execute(sql);	
	}
	_counter = i + 10;
	for (; i <= _counter ; i++ ){	
		var sql = "INSERT INTO `texas_race_room` (`room_id` ,`room_name` ,`room_pass` ,`room_type`,`room_buy` ,`room_cost` ,`room_players` ,`room_expend` ,`room_first_bonus` ,`room_second_bonus` ,`room_third_bonus` ,`room_first_marks` ,`room_second_marks` ,`room_third_marks` ,`room_extension`, `room_class`)VALUES (NULL, '比賽場"+i+"', '','6',  '50000', '5000', '9', '55000', '250000', '135000', '90000', '3', '2', '1', '' ,'')";
		__conn.execute(sql);	
	}
	_counter = i + 10;
	for (; i <= _counter ; i++ ){	
		var sql = "INSERT INTO `texas_race_room` (`room_id` ,`room_name` ,`room_pass` ,`room_type`,`room_buy` ,`room_cost` ,`room_players` ,`room_expend` ,`room_first_bonus` ,`room_second_bonus` ,`room_third_bonus` ,`room_first_marks` ,`room_second_marks` ,`room_third_marks` ,`room_extension`, `room_class`)VALUES (NULL, '比賽場"+i+"', '', '6', '100000', '10000', '9', '110000', '450000', '270000', '180000', '3', '2', '1', '' ,'')";
		__conn.execute(sql);	
	}
	_counter = i + 10;
	for (; i <= _counter ; i++ ){	
		var sql = "INSERT INTO `texas_race_room` (`room_id` ,`room_name` ,`room_pass` ,`room_type`,`room_buy` ,`room_cost` ,`room_players` ,`room_expend` ,`room_first_bonus` ,`room_second_bonus` ,`room_third_bonus` ,`room_first_marks` ,`room_second_marks` ,`room_third_marks` ,`room_extension`, `room_class`)VALUES (NULL, '比賽場"+i+"', '', '6', '200000', '20000', '9', '220000', '900000', '540000', '360000', '3', '2', '1', '' ,'')";
		__conn.execute(sql);	
	}
	_counter = i + 10;
	for (; i <= _counter ; i++ ){	
		var sql = "INSERT INTO `texas_race_room` (`room_id` ,`room_name` ,`room_pass` ,`room_type`,`room_buy` ,`room_cost` ,`room_players` ,`room_expend` ,`room_first_bonus` ,`room_second_bonus` ,`room_third_bonus` ,`room_first_marks` ,`room_second_marks` ,`room_third_marks` ,`room_extension`, `room_class`)VALUES (NULL, '比賽場"+i+"', '', '6', '500000', '50000', '9', '550000', '2500000', '1350000', '900000', '3', '2', '1', '' ,'')";
		__conn.execute(sql);	
	}
	
}
 
